SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vwbformgeneral
AS
SELECT DISTINCT 
                      TOP 100 PERCENT dbo.u_fg_00_varios.Id, dbo.u_cui.cui, dbo.u_jurisdiccion.jurisdiccion, dbo.u_fg_00_varios.departamentocuereferente, 
                      dbo.u_fg_00_varios.localidadparajecuereferente
FROM         dbo.u_fg_00_varios INNER JOIN
                      dbo.u_cui INNER JOIN
                      dbo.u_jurisdiccion ON dbo.u_cui.idjurisdiccion = dbo.u_jurisdiccion.idJurisdiccion ON dbo.u_fg_00_varios.idCui = dbo.u_cui.Id
GO
GRANT SELECT ON  [dbo].[vwbformgeneral] TO [Cenie]
GO
